
image of a light bulb

image of a light bulb
John Tukey
Children's Mercy Hospital building
Cleveland Chiropractic College building
MRI Global building
North Kansas City Hospital building
Saint Luke's Hospital building
Truman Medical Center building
UMKC and KUMC mascots
Russ Waitman
Screenshot of i2b2 software
Diagram of i2b2 schema
## How many surgeries?
select_surgeries <-
"SELECT name_char FROM blueherondata.concept_dimension
WHERE name_char LIKE '%ectomy%'"
dbGetQuery(c_connect, select_surgeries) %>% # Extract records
use_series(NAME_CHAR) %>% # Convert to vector
strsplit(" ") %>% # Split into words
unlist %>% # Re-convert to vector
tolower %>% # Force to lower case
grep("ectomy", ., value=TRUE) %>% # Toss extraneous words
gsub("[[:punct:]]", "", .) %>% # Remove punctuation
gsub("ectomy.*", "-", .) %>% # Remove ectomy suffix
unique %>% # Remove duplicates
sample(100, replace=FALSE) %>% # Select 100 random
sort %>% # Arrange
paste(collapse=", ") # Delimit with commas
"acromion-, adenoid-, alveol-, apic-, apico-, arthr-, arytenoid-, astragal-, ather-, burs-, capsul-, carp-, clitor-, coccyg-, crani-, dacryoaden-, dacryocyst-, diaphys-, disarticulationhemipelv-, disk-, diverticul-, endarter-, epididym-, epiglottid-, epiplo-, ethmoid-, fasci-, fistul-, frenul-, ganglion-, gastr-, gingiv-, gloss-, hemigastr-, hemigloss-, hemilamin-, hemilaryng-, hemiphalang-, hemorrhoid-, hepat-, hymen-, hyster-, infundibul-, irid-, labyrinth-, lamin-, lip-, lump-, mucos-, my-, myom-, nephr-, nephroureter-, oophor-, osteophyt-, pannicul-, patell-, phalang-, pharyngolaryng-, phleb-, pleur-, plex-, pneumon-, postadenoid-, postcholecyst-, postgastr-, postlymphaden-, postmastoid-, postpolyp-, postprostat-, postsplen-, prostat-, rectosigmoid-, salping-, salpingoophor-, scler-, segment-, sequestr-, sialoaden-, sigmoid-, sphenoid-, sympath-, synov-, tenon-, tenosynov-, trabecul-, trachel-, trisection-, trisegment-, turbin-, tyl-, tympanomastoid-, umbil-, urethr-, uvul-, vagin-, valv-, vas-, vesicul-, vulv-"
Mei Liu, next to one of her research publications
<<<<<<< HEAD ======= >>>>>>> 495d4b13430a8f7cba27672caf926040d05f000fTechnical requirements
Non-technical requirements
Flier for May 23 Informatics meetup
This presentation was developed using R Markdown. You can find all the important stuff at
In particular, look for